package com.quwan.mapper;

import com.baomidou.mybatisplus.core.mapper.BaseMapper;
import com.baomidou.mybatisplus.extension.plugins.pagination.Page;
import com.quwan.app.vo.MemberShowInfo;
import com.quwan.entity.TMemberVisit;
import org.apache.ibatis.annotations.Param;
import org.apache.ibatis.annotations.Select;

/**
*
*
* @author quan
* @date 2021-10-22 23:43
*/
 

public interface TMemberVisitMapper extends BaseMapper<TMemberVisit> {
    @Select("select " +
            "m.img_url,m.id mId,m.nick_name,m.gender,m.area from t_member_visit v left  join  t_member m on m.id = v.current_member " +
            "where  v.target_member =#{id} and current_member != -1 and m.id is not null")
    Page<MemberShowInfo> selectVisitList(Page page, @Param("id") String id);
}